package com.auxgroup.hr.front.dao.repository;
import java.math.BigDecimal;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.auxgroup.hr.front.dao.domain.PsCHireFileTbl;
import com.auxgroup.hr.front.dao.domain.PsChireFilePrimary;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCHireFileTblRepository extends
JpaRepository<PsCHireFileTbl,PsChireFilePrimary>,JpaSpecificationExecutor<PsCHireFileTbl> {
	
	@Query("select max(seqno) from PsCHireFileTbl u where u.rsHireId=:rsHireId and u.cFileNum=:cFileNum")
	public BigDecimal getMaxSeqNo(@Param("rsHireId") String rsHireId,@Param("cFileNum") String cFileNum);
}